Solutions of Optimization Problems Using Excel
نویسندگان
چکیده
منابع مشابه
A Genetic Algorithm Using Infeasible Solutions for Constrained Optimization Problems
The use of genetic algorithms (GAs) to solve combinatorial optimization problems often produces a population of infeasible solutions because of optimization problem constraints. A solution pool with a large number of infeasible solutions results in poor search performance of a GA, or worse, the algorithm ceases to run. In such cases, the methods of penalty function and multi-objective optimizat...
متن کاملSolving Configuration Problems in Excel
This work shows how Excel can be leveraged to tackle configuration problems. We demonstrate this by presenting the full development cycle of a PC-configurator prototype. We articulate our demonstration by exemplifying several important points. First, Excel can be used to import raw products and services data. Second, these data can be used by a constraint modelling to correctly instantiate a se...
متن کاملAlgebraic solutions of tropical optimization problems
We consider multidimensional optimization problems, which are formulated and solved in terms of tropical mathematics. The problems are to minimize (maximize) a linear or nonlinear function defined on vectors of a finite-dimensional semimodule over an idempotent semifield, and may have constraints in the form of linear equations and inequalities. The aim of the paper is twofold: first to give a ...
متن کاملCreative OR modeling using Excel to solve combinatorial programming problems
Spreadsheets have grown up and became very powerful and easy to use tools in applying analytical techniques for solving business problems. Operations managers, production managers, planners and schedulers can work with them in developing solid and practical Do-It-Yourself Decision Support Systems. Small and Medium size organizations, can apply OR methodologies without the presence of specialize...
متن کاملFinding Robust Solutions to Dynamic Optimization Problems
Most research in evolutionary dynamic optimization is based on the assumption that the primary goal in solving Dynamic Optimization Problems (DOPs) is Tracking Moving Optimum (TMO). Yet, TMO is impractical in cases where keeping changing solutions in use is impossible. To solve DOPs more practically, a new formulation of DOPs was proposed recently, which is referred to as Robust Optimization Ov...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Journal of Applied Sciences
سال: 2001
ISSN: 1812-5654
DOI: 10.3923/jas.2002.92.96